<!DOCTYPE HTML>
<!--
	Dimension by HTML5 UP
	html5up.net | @ajlkn
	Free for personal and commercial use under the CCA 3.0 license (html5up.net/license)
-->
<html>
 <head>
  <title>
   Dimension by HTML5 UP
  </title>
  <!-- <meta charset="utf-8" /> -->
  <!-- <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no" /> -->
  <meta charset="utf-8"/>
  <meta content="width=device-width,initial-scale=1.0" name="viewport"/>
  <link href="../../assets/css/article.css" rel="stylesheet"/>
  <link href="https://cdn.bootcss.com/highlight.js/9.15.8/styles/github.min.css" rel="stylesheet"/>
  <noscript>
   <link href="../../assets/css/noscript.css" rel="stylesheet"/>
  </noscript>
 </head>
 <body>
  <div id="app">
  </div>
  <!-- built files will be auto injected -->
 </body>
 <body class="is-preload">
  <!-- Wrapper -->
  <div id="wrapper">
   <!-- Main -->
   <div id="main">
    <article id="article">
     <h1 id="mysql">
      MySQL使用记录
     </h1>
     <hr/>
     <h2 id="_1">
      安装
     </h2>
     <h3 id="centos7">
      centos7
     </h3>
     <div class="codehilite">
      <pre><span></span><code>wget <span class="s1">'https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm'</span>
rpm -Uvh mysql57-community-release-el7-11.noarch.rpm
yum install mysql-community-server
systemctl start mysqld
systemctl <span class="nb">enable</span> mysqld

grep <span class="s1">'temporary password'</span> /var/log/mysqld.log
mysql -u root -p
ALTER USER <span class="s1">'root'</span>@<span class="s1">'localhost'</span> IDENTIFIED BY <span class="s1">'MyNewPass4!'</span><span class="p">;</span>
grant all privileges on *.* to <span class="s1">'root'</span>@<span class="s1">'%'</span> identified by <span class="s2">"123456"</span> with grant option<span class="p">;</span>
flush privileges<span class="p">;</span>
</code></pre>
     </div>
     <h2 id="_2">
      常用命令记录
     </h2>
     <div class="codehilite">
      <pre><span></span><code><span class="k">create</span> <span class="k">user</span> <span class="k">share</span><span class="o">@</span><span class="s1">'%'</span> <span class="n">identified</span> <span class="k">by</span> <span class="s1">'password'</span><span class="p">;</span>
<span class="k">set</span> <span class="n">password</span> <span class="k">for</span> <span class="s1">'share'</span><span class="o">@</span><span class="s1">'%'</span><span class="o">=</span><span class="n">password</span><span class="p">(</span><span class="s1">'share'</span><span class="p">);</span>
<span class="k">grant</span> <span class="k">select</span> <span class="k">on</span> <span class="n">bachang</span><span class="p">.</span><span class="n">index1</span> <span class="k">to</span> <span class="k">share</span><span class="o">@</span><span class="s1">'%'</span> <span class="p">;</span>
<span class="k">grant</span> <span class="k">select</span> <span class="k">on</span> <span class="n">bachang</span><span class="p">.</span><span class="n">index2</span> <span class="k">to</span> <span class="k">share</span><span class="o">@</span><span class="s1">'%'</span> <span class="p">;</span>
<span class="k">revoke</span> <span class="k">insert</span> <span class="k">on</span> <span class="n">bachang</span><span class="p">.</span><span class="n">attack_info</span> <span class="k">from</span> <span class="n">worker</span><span class="o">@</span><span class="s1">'%'</span><span class="p">;</span>
<span class="k">grant</span> <span class="k">select</span> <span class="k">on</span> <span class="n">bachang</span><span class="p">.</span><span class="n">vulnerability</span> <span class="k">to</span> <span class="n">worker</span><span class="o">@</span><span class="s1">'%'</span><span class="p">;</span>

<span class="k">delete</span> <span class="k">from</span> <span class="err">表名</span><span class="p">;</span>

<span class="k">drop</span> <span class="k">database</span> <span class="n">databasename</span><span class="p">;</span>

<span class="o">#</span> <span class="n">MySQL查看所有连接的客户端ip</span>
<span class="k">SELECT</span> <span class="n">substring_index</span><span class="p">(</span><span class="k">host</span><span class="p">,</span> <span class="s1">':'</span><span class="p">,</span><span class="mi">1</span><span class="p">)</span> <span class="k">AS</span> <span class="n">host_name</span><span class="p">,</span><span class="k">state</span><span class="p">,</span><span class="k">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span> <span class="k">FROM</span> <span class="n">information_schema</span><span class="p">.</span><span class="n">processlist</span> <span class="k">GROUP</span> <span class="k">BY</span> <span class="k">state</span><span class="p">,</span><span class="n">host_name</span><span class="p">;</span>
</code></pre>
     </div>
     <h2 id="_3">
      语句使用
     </h2>
     <h3 id="_4">
      建库、建表一般语句
     </h3>
     <div class="codehilite">
      <pre><span></span><code><span class="o">#</span> <span class="err">用于用户数据库及表的初始化</span>

<span class="k">CREATE</span> <span class="k">DATABASE</span> <span class="k">if</span> <span class="k">not</span> <span class="k">exists</span> <span class="o">`</span><span class="n">mall</span><span class="o">`</span><span class="p">;</span>

<span class="n">USE</span> <span class="o">`</span><span class="n">mall</span><span class="o">`</span><span class="p">;</span>

<span class="o">#</span> <span class="err">用户表</span>
<span class="k">CREATE</span> <span class="k">TABLE</span> <span class="k">IF</span> <span class="k">NOT</span> <span class="k">EXISTS</span> <span class="o">`</span><span class="n">users</span><span class="o">`</span> <span class="p">(</span>
  <span class="o">`</span><span class="n">id</span><span class="o">`</span> <span class="nb">int</span><span class="p">(</span><span class="mi">11</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span> <span class="n">AUTO_INCREMENT</span><span class="p">,</span>
  <span class="o">`</span><span class="n">name</span><span class="o">`</span> <span class="nb">varchar</span><span class="p">(</span><span class="mi">16</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
  <span class="o">`</span><span class="n">password</span><span class="o">`</span> <span class="nb">varchar</span><span class="p">(</span><span class="mi">16</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
  <span class="o">`</span><span class="n">phoneNumber</span><span class="o">`</span> <span class="nb">varchar</span><span class="p">(</span><span class="mi">15</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
  <span class="o">`</span><span class="n">money</span><span class="o">`</span> <span class="nb">int</span><span class="p">(</span><span class="mi">11</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
  <span class="k">PRIMARY</span> <span class="k">KEY</span> <span class="p">(</span><span class="o">`</span><span class="n">id</span><span class="o">`</span><span class="p">)</span>
<span class="p">)</span> <span class="n">ENGINE</span><span class="o">=</span><span class="n">InnoDB</span> <span class="n">AUTO_INCREMENT</span><span class="o">=</span><span class="mi">1</span> <span class="k">DEFAULT</span> <span class="n">CHARSET</span><span class="o">=</span><span class="n">latin1</span><span class="p">;</span>

<span class="o">#</span> <span class="err">商品表</span>
<span class="k">CREATE</span> <span class="k">TABLE</span> <span class="k">IF</span> <span class="k">NOT</span> <span class="k">EXISTS</span> <span class="o">`</span><span class="n">goods</span><span class="o">`</span> <span class="p">(</span>
    <span class="o">`</span><span class="n">id</span><span class="o">`</span> <span class="nb">int</span><span class="p">(</span><span class="mi">11</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span> <span class="n">AUTO_INCREMENT</span><span class="p">,</span>
    <span class="o">`</span><span class="n">name</span><span class="o">`</span> <span class="nb">varchar</span><span class="p">(</span><span class="mi">16</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
    <span class="o">`</span><span class="n">description</span><span class="o">`</span> <span class="nb">varchar</span><span class="p">(</span><span class="mi">1024</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
    <span class="o">`</span><span class="n">store_id</span><span class="o">`</span> <span class="nb">int</span><span class="p">(</span><span class="mi">11</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
    <span class="o">`</span><span class="n">store_name</span><span class="o">`</span> <span class="nb">varchar</span><span class="p">(</span><span class="mi">16</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
    <span class="o">`</span><span class="n">status</span><span class="o">`</span> <span class="nb">int</span><span class="p">(</span><span class="mi">1</span><span class="p">)</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span>
    <span class="k">PRIMARY</span> <span class="k">KEY</span> <span class="p">(</span><span class="o">`</span><span class="n">id</span><span class="o">`</span><span class="p">),</span>
    <span class="k">foreign</span> <span class="k">key</span> <span class="p">(</span><span class="n">store_id</span><span class="p">)</span> <span class="k">references</span> <span class="n">stores</span><span class="p">(</span><span class="n">id</span><span class="p">)</span>
<span class="p">)</span> <span class="n">ENGINE</span><span class="o">=</span><span class="n">InnoDB</span> <span class="n">AUTO_INCREMENT</span><span class="o">=</span><span class="mi">1</span> <span class="k">DEFAULT</span> <span class="n">CHARSET</span><span class="o">=</span><span class="n">latin1</span><span class="p">;</span>
<span class="o">#</span> <span class="k">SQL</span> <span class="k">FOREIGN</span> <span class="k">KEY</span> <span class="err">约束</span><span class="p">:</span><span class="n">https</span><span class="p">:</span><span class="o">//</span><span class="n">www</span><span class="p">.</span><span class="n">runoob</span><span class="p">.</span><span class="n">com</span><span class="o">/</span><span class="k">sql</span><span class="o">/</span><span class="k">sql</span><span class="o">-</span><span class="n">foreignkey</span><span class="p">.</span><span class="n">html</span>

<span class="k">insert</span> <span class="k">into</span> <span class="n">mall</span><span class="p">.</span><span class="n">stores</span> <span class="p">(</span><span class="n">name</span><span class="p">,</span> <span class="n">description</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span><span class="ss">"name"</span><span class="p">,</span> <span class="ss">"description"</span><span class="p">);</span>
<span class="k">insert</span> <span class="k">into</span> <span class="n">mall</span><span class="p">.</span><span class="n">goods</span><span class="p">(</span><span class="n">name</span><span class="p">,</span> <span class="n">description</span><span class="p">,</span> <span class="n">store_id</span><span class="p">,</span> <span class="n">store_name</span><span class="p">,</span> <span class="n">status</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span><span class="ss">"name"</span><span class="p">,</span> <span class="ss">"description"</span><span class="p">,</span> <span class="mi">1</span><span class="p">,</span> <span class="ss">"name"</span><span class="p">,</span>
                                                                                    <span class="mi">1</span><span class="p">);</span>
<span class="ss">"value"</span><span class="err">}'</span><span class="p">);</span>
</code></pre>
     </div>
     <h3 id="_5">
      初始化数据：循环插入、随机数、字符串拼接
     </h3>
     <div class="codehilite">
      <pre><span></span><code><span class="k">DROP</span> <span class="k">PROCEDURE</span> <span class="k">IF</span> <span class="k">EXISTS</span> <span class="n">users_initData</span><span class="p">;</span>
<span class="k">DELIMITER</span> <span class="err">$</span>
<span class="k">CREATE</span> <span class="k">PROCEDURE</span> <span class="n">users_initData</span><span class="p">()</span>
<span class="k">BEGIN</span>
    <span class="k">DECLARE</span> <span class="n">i</span> <span class="nb">INT</span> <span class="k">DEFAULT</span> <span class="mi">1</span><span class="p">;</span>
    <span class="n">WHILE</span> <span class="n">i</span><span class="o">&lt;=</span><span class="mi">100</span> <span class="k">DO</span>
        <span class="k">insert</span> <span class="k">into</span> <span class="n">mall</span><span class="p">.</span><span class="n">users</span> <span class="p">(</span><span class="n">name</span><span class="p">,</span> <span class="n">password</span><span class="p">,</span> <span class="n">phoneNumber</span><span class="p">,</span> <span class="n">money</span><span class="p">)</span> <span class="k">VALUES</span> <span class="p">(</span><span class="n">CONCAT</span><span class="p">(</span><span class="ss">"user"</span><span class="p">,</span> <span class="n">i</span><span class="p">),</span> <span class="ss">"password"</span><span class="p">,</span>
                                                                            <span class="n">CONCAT</span><span class="p">(</span><span class="ss">"phoneNumber"</span><span class="p">,</span> <span class="n">i</span><span class="p">),</span> <span class="mi">0</span><span class="p">);</span>
        <span class="k">SET</span> <span class="n">i</span> <span class="o">=</span> <span class="n">i</span><span class="o">+</span><span class="mi">1</span><span class="p">;</span>
    <span class="k">END</span> <span class="n">WHILE</span><span class="p">;</span>
<span class="k">END</span> <span class="err">$</span>
<span class="k">CALL</span> <span class="n">users_initData</span><span class="p">();</span>

<span class="k">DROP</span> <span class="k">PROCEDURE</span> <span class="k">IF</span> <span class="k">EXISTS</span> <span class="n">goods_initData</span><span class="p">;</span>
<span class="k">DELIMITER</span> <span class="err">$</span>
<span class="k">CREATE</span> <span class="k">PROCEDURE</span> <span class="n">goods_initData</span><span class="p">()</span>
<span class="k">BEGIN</span>
    <span class="k">DECLARE</span> <span class="n">i</span> <span class="nb">INT</span> <span class="k">DEFAULT</span> <span class="mi">1</span><span class="p">;</span>
    <span class="n">WHILE</span> <span class="n">i</span><span class="o">&lt;=</span><span class="mi">10000</span> <span class="k">DO</span>
        <span class="k">insert</span> <span class="k">into</span> <span class="n">mall</span><span class="p">.</span><span class="n">goods</span><span class="p">(</span><span class="n">name</span><span class="p">,</span> <span class="n">description</span><span class="p">,</span> <span class="n">store_id</span><span class="p">,</span> <span class="n">store_name</span><span class="p">,</span> <span class="n">status</span><span class="p">)</span>
        <span class="k">VALUES</span> <span class="p">(</span><span class="n">CONCAT</span><span class="p">(</span><span class="ss">"name"</span><span class="p">,</span> <span class="n">i</span><span class="p">),</span> <span class="n">CONCAT</span><span class="p">(</span><span class="ss">"description"</span><span class="p">,</span> <span class="n">i</span><span class="p">),</span> <span class="n">CEILING</span><span class="p">(</span><span class="n">rand</span><span class="p">()</span><span class="o">*</span><span class="mi">100</span><span class="p">),</span> <span class="ss">"storeName"</span><span class="p">,</span> <span class="mi">1</span><span class="p">);</span>
        <span class="k">SET</span> <span class="n">i</span> <span class="o">=</span> <span class="n">i</span><span class="o">+</span><span class="mi">1</span><span class="p">;</span>
    <span class="k">END</span> <span class="n">WHILE</span><span class="p">;</span>
<span class="k">END</span> <span class="err">$</span>
<span class="k">CALL</span> <span class="n">goods_initData</span><span class="p">();</span>
</code></pre>
     </div>
     <h3 id="_6">
      统计相关
     </h3>
     <div class="codehilite">
      <pre><span></span><code><span class="k">select</span> <span class="n">timestampdiff</span><span class="p">(</span><span class="n">week</span><span class="p">,</span><span class="s1">'2011-09-30'</span><span class="p">,</span><span class="s1">'2015-05-04'</span><span class="p">);</span>
</code></pre>
     </div>
     <h3 id="_7">
      开启/关闭 安全模式
     </h3>
     <div class="codehilite">
      <pre><span></span><code><span class="o">#</span> <span class="err">因为</span><span class="n">MySql运行在safe</span><span class="o">-</span><span class="n">updates模式下</span><span class="err">，该模式会导致非主键条件下无法执行</span><span class="n">update或者delete命令</span><span class="err">，执行命令如下命令关闭安全模式</span><span class="p">.</span>
<span class="k">SET</span> <span class="n">SQL_SAFE_UPDATES</span> <span class="o">=</span> <span class="mi">0</span><span class="p">;</span>
</code></pre>
     </div>
     <h3 id="_8">
      大于小于之类的写法
     </h3>
     <div class="codehilite">
      <pre><span></span><code><span class="err">第一种写法（</span><span class="mi">1</span><span class="err">）：</span>

<span class="err">原符号</span>       <span class="o">&lt;</span>        <span class="o">&lt;=</span>      <span class="o">&gt;</span>       <span class="o">&gt;=</span>       <span class="o">&amp;</span>        <span class="err">'</span>        <span class="err">"</span>
<span class="err">替换符号</span>    <span class="o">&amp;</span><span class="n">lt</span><span class="p">;</span>    <span class="o">&amp;</span><span class="n">lt</span><span class="p">;</span><span class="o">=</span>   <span class="o">&amp;</span><span class="n">gt</span><span class="p">;</span>    <span class="o">&amp;</span><span class="n">gt</span><span class="p">;</span><span class="o">=</span>   <span class="o">&amp;</span><span class="n">amp</span><span class="p">;</span>   <span class="o">&amp;</span><span class="n">apos</span><span class="p">;</span>  <span class="o">&amp;</span><span class="n">quot</span><span class="p">;</span>
<span class="err">例如：</span><span class="n">sql如下</span><span class="err">：</span>
<span class="n">create_date_time</span> <span class="o">&amp;</span><span class="n">gt</span><span class="p">;</span><span class="o">=</span> <span class="o">#</span><span class="err">{</span><span class="n">startTime</span><span class="err">}</span> <span class="k">and</span>  <span class="n">create_date_time</span> <span class="o">&amp;</span><span class="n">lt</span><span class="p">;</span><span class="o">=</span> <span class="o">#</span><span class="err">{</span><span class="n">endTime</span><span class="err">}</span>

<span class="err">第二种写法（</span><span class="mi">2</span><span class="err">）：</span>
<span class="err">大于等于</span>
<span class="o">&lt;!</span><span class="p">[</span><span class="n">CDATA</span><span class="p">[</span> <span class="o">&gt;=</span> <span class="p">]]</span><span class="o">&gt;</span>
<span class="err">小于等于</span>
<span class="o">&lt;!</span><span class="p">[</span><span class="n">CDATA</span><span class="p">[</span> <span class="o">&lt;=</span> <span class="p">]]</span><span class="o">&gt;</span>
<span class="err">例如：</span><span class="n">sql如下</span><span class="err">：</span>
<span class="n">create_date_time</span> <span class="o">&lt;!</span><span class="p">[</span><span class="n">CDATA</span><span class="p">[</span> <span class="o">&gt;=</span> <span class="p">]]</span><span class="o">&gt;</span> <span class="o">#</span><span class="err">{</span><span class="n">startTime</span><span class="err">}</span> <span class="k">and</span>  <span class="n">create_date_time</span> <span class="o">&lt;!</span><span class="p">[</span><span class="n">CDATA</span><span class="p">[</span> <span class="o">&lt;=</span> <span class="p">]]</span><span class="o">&gt;</span> <span class="o">#</span><span class="err">{</span><span class="n">endTime</span><span class="err">}</span>
</code></pre>
     </div>
     <h3 id="_9">
      修改字段默认值
     </h3>
     <div class="codehilite">
      <pre><span></span><code><span class="k">alter</span> <span class="k">table</span> <span class="err">表名</span> <span class="k">alter</span> <span class="k">column</span> <span class="err">字段名</span> <span class="k">drop</span> <span class="k">default</span><span class="p">;</span> <span class="p">(</span><span class="err">若本身存在默认值，则先删除</span><span class="p">)</span>

<span class="k">alter</span> <span class="k">table</span> <span class="err">表名</span> <span class="k">alter</span> <span class="k">column</span> <span class="err">字段名</span> <span class="k">set</span> <span class="k">default</span> <span class="err">默认值</span><span class="p">;(</span><span class="err">若本身不存在则可以直接设定</span><span class="p">)</span>
</code></pre>
     </div>
     <h3 id="_10">
      查询空字段
     </h3>
     <div class="codehilite">
      <pre><span></span><code><span class="o">#</span> <span class="err">使用</span> <span class="k">is</span> <span class="k">null</span> <span class="err">，而不是</span><span class="o">==</span><span class="k">null</span>
<span class="k">select</span> <span class="o">*</span> <span class="k">from</span> <span class="n">test</span> <span class="k">where</span> <span class="n">t_birth</span> <span class="k">is</span> <span class="k">null</span><span class="p">;</span>
</code></pre>
     </div>
     <h3 id="_11">
      日志查看
     </h3>
     <p>
      <code>
       shell script
sudo tail -f /var/log/mysql/mysql.log
      </code>
     </p>
     <h2 id="_12">
      参考链接
     </h2>
     <ul>
      <li>
       <a href="https://www.cnblogs.com/gpdm/p/6492449.html">
        mysql-创建用户并授权，设置允许远程连接
       </a>
      </li>
      <li>
       <a href="https://www.cnblogs.com/wuyifu/p/7580494.html">
        创建MySQL用户 赋予某指定库表的权限
       </a>
      </li>
      <li>
       <a href="https://www.jianshu.com/p/7cccdaa2d177">
        Centos 7 安装 MySQL
       </a>
      </li>
      <li>
       <a href="https://blog.csdn.net/song634/article/details/80394965">
        centos7下mysql配置远程连接
       </a>
      </li>
      <li>
       <a href="https://www.runoob.com/mysql/mysql-alter.html">
        MySQL ALTER命令
       </a>
      </li>
      <li>
       <a href="https://blog.csdn.net/guo_qiangqiang/article/details/90480945">
        mysql sum() 求和函数和TIMESTAMPDIFF时间差函数相结合的用法
       </a>
      </li>
      <li>
       <a href="https://blog.csdn.net/xuanzhangran/article/details/60329357">
        mybatis中大于等于小于等于的写法
       </a>
      </li>
      <li>
       <a href="https://www.cnblogs.com/hellojesson/p/6025548.html">
        Mysql 修改字段默认值
       </a>
      </li>
      <li>
       <a href="https://blog.csdn.net/gymaisyl/article/details/83932495">
        MySQL数据库日志的查看
       </a>
      </li>
      <li>
       <a href="https://www.cnblogs.com/tianhuilove/archive/2011/09/05/2167795.html">
        MySQL索引的创建、删除和查看
       </a>
      </li>
      <li>
       <a href="https://blog.csdn.net/Small_bottle_cap/article/details/93845866">
        Mysql：给有重复记录的表添加唯一索引
       </a>
      </li>
      <li>
       <a href="https://cloud.tencent.com/developer/article/1533785">
        MySQL之alter ignore 语法
       </a>
      </li>
      <li>
       <a href="https://blog.csdn.net/bitcarmanlee/article/details/51100279">
        distinct 多列详解
       </a>
      </li>
      <li>
       <a href="https://blog.csdn.net/l1028386804/article/details/51733585">
        MySQL之——查询重复记录、删除重复记录方法大全
       </a>
      </li>
      <li>
       <a href="https://blog.csdn.net/zyz511919766/article/details/49335897">
        MySQL中数据库重命名
       </a>
      </li>
      <li>
       <a href="https://blog.csdn.net/Mrqiang9001/article/details/101381500">
        MySQL查询字段为空(null)时设置默认值
       </a>
      </li>
      <li>
       <a href="https://www.cnblogs.com/freeweb/p/5210762.html">
        修改MySQL中字段的类型和长度
       </a>
      </li>
     </ul>
    </article>
   </div>
   <!-- Footer -->
   <footer id="footer">
    <p class="copyright">
     © Untitled. Design:
     <a href="https://html5up.net">
      HTML5 UP
     </a>
     .
    </p>
   </footer>
  </div>
  <!-- BG -->
  <div id="bg">
  </div>
  <!-- Scripts -->
  <script src="../assets/js/jquery.min.js">
  </script>
  <script src="../assets/js/browser.min.js">
  </script>
  <script src="../assets/js/breakpoints.min.js">
  </script>
  <script src="../assets/js/util.js">
  </script>
  <script src="../assets/js/main.js">
  </script>
 </body>
</html>
